
[dbo].[BAEFieldDesignGetAllByNoSection]
create procedure [dbo].[BAEFieldDesignGetAllByNoSection] as
SELECT *
FROM FieldDesign
WHERE
FieldDesign.FieldName
NOT IN
(SELECT FieldDesignSectionLookup.FieldName
FROM FieldDesignSectionLookup, FieldDesign
WHERE FieldDesignSectionLookup.TableName = FieldDesign.TableName)
GO